Variable explanation for EDGAR

Import data

subedgar20160110<-read.csv("/Users/sn0wfree/Dropbox/InvestorAttention_data/R_datashow/log20160111.csv",header=1)

Show the First 10 Rows of log20160111

head(subedgar20160110, n=10)

Caption (Brief):

Variable name	Discription	Variable name	Discription
IP Address	IP (###.###.###.xxx)	Size	The size of the requested documents.
Date	Apache log file date	Idx	Dummy variable: 1 for the requesters come from the index page, and zero otherwise.
time	Apache log file time	Norefer	1 for the referrer field is empty; and zero otherwise
zone	Apache log file zone	Noagent	1 for the user agent field is empty; and zero otherwise
cik	SEC Central Index Key (CIK)/ Company Code/Indidividual code.	Find	The category variable (0-10), categoried by the characters found in the referrer field, Detail please see below: Caption (Detail)
accession	the SEC document accession number of requested documents.	crawler	1 for non-robots; 0 for robots.
extention	the extention name of requested file, or CIK if miss the extention name.	browser	Category variables (string variables), to show the which device or internet browser the requester use
Code	Apache log file status code for the request

---

Caption (Detail):

• IP : This variable provides the first three octets of the IP address with the fourth octet obfuscated with a 3 character string that preserves the uniqueness of the last octet without revealing the full identity of the IP (###.###.###.xxx). For example, all fourth octets of 150 will have the same three character string across all files
• Date: Apache log file date
• time: Apache log file time
• zone: Apache log file zone
• cik: SEC Central Index Key (CIK) associated with the document requested: company code
• accession: SEC document accession number associated with the document requested
• extention: doc: This variable provides the filename of the file requested including the document extension. If the filename is missing and only the file extension is present, then the filename is the document accession number.
• Code: Apache log file status code for the request
• Size: document file size

• Idx: takes on a value of 1 if the requester landed on the index page of a set of documents (e.g., - index.htm), and zero otherwise

• Norefer: takes on a value of one if the Apache log file referrer field is empty, and zero otherwise

• Noagent: takes on a value of one if the Apache log file user agent field is empty, and zero otherwise

• Find: numeric values from 0 to 10, that correspond to whether the following character strings/[$string]/were found in the referrer field – this could indicate how the document requester arrived at the document link (e.g., internal EDGAR search):

1. $find=0;
2. if(\(referrer=~m/.*(action\=getcompany)/){\)find=1};
   
3. if(\(referrer=~m/.*(action\=getcurrent)/){\)find=2};
   
4. if(\(referrer=~m/.*(Find\+Companies)/){\)find=3};
   
5. if(\(referrer=~m/.*(cgi\-bin\/srch\-edgar)/){\)find=4};
   
6. if(\(referrer=~m/.*(EDGARFSClient)/){\)find=5};
   
7. if(\(referrer=~m/.*(cgi\-bin\/current)/){\)find=6};
   
8. if(\(referrer=~m/.*(Archives\/edgar)/){\)find=7};
   
9. if(\(referrer=~m/.*(cgi\-bin\/viewer)/){\)find=8};
   
10. if(\(referrer=~m/.*(.*\-index)/){\)find=9};

crawler: This variable takes on a value of one if the user agent self-identifies as one of the following webcrawlers or has a user code of 404. Below are the actual Perl regular expressions used: 1. if(\(agent=~m/(wget|Googlebot|polybot|Yahoo\!\s*Slurp|spider|robot|perl|python|lwp|crawler)/i){\)crawl=1}; 2. if(\(code==404){\)crawl=1}; browser: This variable is a three character string that identifies potential browser type by analyzing whether the user agent field contained the following /[text]/. Below are the actual Perl regular expressions used: 1. if(\(agent=~m/MSIE/){\)browser=“mie”}; 2. if(\(agent=~m/Firefox/){\)browser=“fox”}; 3. if(\(agent=~m/Safari/){\)browser=“saf”}; 4. if(\(agent=~m/Chrom/){\)browser=“chr”};
5. if(\(agent=~m/Seamonk/){\)browser=“sea”}; 6. if(\(agent=~m/Opera/){\)browser=“opr”}; 7. if(\(agent=~m/(DoCoMo|KDDI|Cricket|Vodaphone)/){\)browser=“oth”}; 8. if(\(agent=~m/Windows\s*NT/){\)browser=“win”}; 9. if(\(agent=~m/Mac\s*OS/i){\)browser=“mac”}; 10. if(\(agent=~m/Linux/i){\)browser=“lin”}; 11. if(\(agent=~m/iPhone/){\)browser=“iph”}; 12. if(\(agent=~m/iPad/){\)browser=“ipd”}; 13. if(\(agent=~m/Android/){\)browser=“and”}; 14. if(\(agent=~m/(BB10|PlayBook|BlackBerry)/){\)browser=“rim”}; 15. if(\(agent=~m/(IEMobile|Windows\s*CE|Windows\s*Phone)/){\)browser=“iem”};